<?php

interface DB{

	//method for Country Table
	public function getCountry(); // to get all country list
	public function getCountryById(int $countryId); // to get country by id
	public function setCountry(String $countryName); // to insert the country
	public function setCountryById(int $countryId, String $countryName);
	public function removeCountry(); // to delete all country
	public function removeCountryById(int $countryId); // to delete the country by Id


	// method for State Table
	public function getState(); // to get all state list
	public function getStateByCountryId(int $countryId);
	public function getStateById(int $counrtyId,int $stateId);	// to get the state by state and country
	public function setState(int $countryId, String $stateName);	// to insert the state
	public function setStateById(int $countryId, int $stateId, String $stateName);	// to update the state
	public function removeStateByCounrtyId(int $counrtyId); // to delete all state by Country Id
	public function removeStateById(int $countryId, int $stateId); // to delete state by Id


	// method for City Table
	public function getCity(); // to get all city
	public function getCityByStateId(int $stateId); // to get city by State By
	public function getCityById(int $cityId); // to get City by City Id
	public function setCity(String $cityName); // to insert the city name
	public function setCityById(int $cityId, String $cityName); // to update the city
	public function removeCity(); // to delete all City
	public function removeCityById(int $cityId); // to remove the city by Id

	// method for education Table
	public function getEducation(); // to get all education
	public function getEducationById(int $educationId); // to get the education by Id
	public function setEducation(String $educationName); //to insert the education
	public function setEducationByID(int $educationId, String $educationName); // to update education
	public function removeEducation(); // to delete the all education a
	public function removeEducationById(int $educationId); // to delete the education by Id

	// method for gotra Table

	public function getGorta(); // to get all gotra
	public function getGortaById(int $gotraId); // to get the Gotra by Id
	public function setGotra(String $gotraName); // to insert the Gotra
	public function setGortaById(int $gotraId, String $gotraName); // to update the gotra By Id
	public function removeGotra(); // to remove the all gotra
	public function removeGortraById(int $gotraId); // to remove the gotra By id

	// method for users Table
	public function getUsers(); // to get all users
	public function getUserById(int $userId); // to get user by id
	public function getUserByUsername(String $userName); // to get user by UserName
	public function setUser(String $userName, String $password, int $counrtyId, int $stateId, int $cityId, String $email, int $mobile); //to insert the user
	public function setUserById(int $userId, String $userName, String $password, int $countryId, int $stateId, int $cityId, String $email, String $mobile); // to update the user
	public function removeUsers(); // to remove all users
	public function removeUserById(int $userId); // to remove user by Id
	public function removeUserByUserName(int $userId); // to remove user by Id
	public function checkUser(String $userName, String $password); // check username and password for login verification

	// method for Family Table
	public function getFamily(); // to get all family
	public function getFamilyById(int $familyId); // to get Family By Id
	public function getFamilyByFamilyName(String $familyName);
	public function setFamily(String $familyName, int $countryId, int $stateId, int $cityId, String $address, int $gotraId); // to insert the  Family
	public function setFamilyById(int $familyId, String $familyName, int $countryId, int $stateId, int $cityId, String $address, int $gotraId ); // to update the family by id
	public function removeFamily(); // to delete all the family
	public function removeFamilyById(int $familyId); // to delete the family by id
	public function removeFamilyByFamilyName(String $familyName); // to delete the family by family Name

















}
?>